sql = """
insert into c_cons_copy1
select t1.cons_no, t2.city_org_no, t1.shi, t2.org_no, t1.xian,  t1.cons_no cons_name, t1.type_code, t1.type_code_sort
from
(select cons_no, shi, xian, cons_name, type_code, 1 type_code_sort
from c_cons)t1
left join 
(select org_no, city_org_no, org_name
from real_org_no) t2
on t1.xian = t2.org_name;


alter table c_cons rename to c_cons_copy2;

alter table c_cons_copy1 rename to c_cons;

insert into area_type_map
select distinct org_no, org_name, type_code, type_code_sort from c_cons;
"""
